﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
create PROCEDURE [dbo].[proc_App_Menu_GetMenuPublicExt] 
(
	@MId varchar(100)
)
AS
BEGIN
SELECT 
		[ID],
		[MID]
		,[MName]
		,[MPath]
		,[Msort]
FROM App_Menu 
WHERE LEN(MID)=LEN(@MID)+2 AND MID like @MID+'%'
ORDER BY [Msort]
End